SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 91818 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 91818 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796080,668432,941160,947340,685400,477768,857116,1031180,925659,1023409,535204,584490,324628,808848,833114,869838,364960,1044043,285678,437578,423829,636067,833793,150250,810418,866949,117170,41579,185082,864102,283983,626785,939227,601607,395315,809363,27714,982935,404840,756121,907714,197317,967308,300108,94614,191772,313119,646549,809700,806080,463757,21576,305814,424675,734332,44719,66531,633389,921100,822185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 91818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 91818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]