SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514122 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514122 [ RunTime:0.003471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287809,464775,60910,121466,826383,1042691,317707,996123,147015,77008,208279,681546,805962,300925,376627,545762,1035839,88076,274230,997277,841296,135688,596197,235548,668579,658410,173270,61884,818778,991202,648502,633302,356958,472147,109508,121741,636611,662929,711868,190563,823739,56966,1027244,1034686,255661,889350,627062,926789,336105,887742,628218,874156,802219,989714,1044890,894929,306033,923926,39703,465737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]