SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 968308 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 968308 [ RunTime:0.001420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939703,174011,543254,190401,803917,966814,69902,1002860,722320,750519,260468,686234,318700,712144,335293,1019125,741078,14363,543411,236700,717944,247247,747104,254824,901245,922774,342986,417464,1047278,521119,505887,320304,1022767,138923,919396,232580,810276,247013,298937,24814,791300,239307,100504,65019,876066,989832,167914,22240,1027202,369976,336834,627131,846399,657992,297751,903958,845121,39811,427652,338526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 968308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 968308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]