SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037012 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037012 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480115,97124,358400,220843,628222,257376,223951,855740,728607,54825,741657,370259,92369,225861,521449,181621,520950,477146,851675,742476,85291,487329,135469,43241,885837,750860,94705,868340,1027809,11355,249187,10238,608765,508663,111062,230810,662183,428650,47646,624795,422516,396054,35309,336309,139551,536980,279838,788011,203680,281650,636222,275767,899857,548005,826134,76724,389622,960490,777042,787414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001135s ]