SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002163 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002163 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284208,165388,330205,779689,268667,581075,977947,933915,82462,540803,1012477,271252,26179,395899,227693,729981,770138,862332,412399,379596,385744,958375,895563,465070,1035028,426340,769606,58203,391505,1018894,1031779,932190,88057,571299,298284,289142,27956,67102,437631,208991,780513,351519,392981,741895,585548,1038248,406698,333973,237372,310200,434740,117228,581487,305394,136151,631492,632046,914490,283787,812980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]