SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 978780 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 978780 [ RunTime:0.002088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543664,889167,1038289,709429,144498,1026898,137894,255081,302000,763415,162835,243688,357761,590352,481412,714215,842806,310846,125712,366195,132334,301589,550704,979968,742150,768654,486649,854915,425020,944793,120354,351206,785955,958424,126197,494508,447358,877439,1026219,488027,78032,31320,20667,641679,1012938,352717,100962,448566,209940,16665,419870,36457,809517,859823,813789,11145,1039894,1012102,276133,370465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 978780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 978780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]