SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 251841 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 251841 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312029,775010,671905,476905,161387,28202,817621,1033974,309290,414072,673654,1037866,841787,369969,374509,179181,1025613,596901,742128,395432,319653,640509,283573,704350,721276,839094,617352,314812,837834,364755,688770,838990,762550,425614,383086,620047,473792,809848,474424,240461,510954,28747,639308,393935,706334,80532,1036689,537301,942128,873776,577498,726790,149426,199518,806034,545178,589559,165699,226351,273994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 251841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 251841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]