SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037116 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037116 [ RunTime:0.002668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547247,892070,921419,757182,32239,6097,167519,810848,832992,1021139,873586,519295,993033,682814,718195,391304,487150,521963,531669,496697,172087,418603,888041,40538,314904,428866,805787,603415,396752,538648,816421,864525,833960,17618,272988,195617,791961,58855,1017641,159302,29602,331505,373815,299943,254255,308302,406940,765203,714445,904014,389815,305707,572623,533337,749541,630894,679638,415485,1020327,332281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]