SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423101 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423101 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586198,3468,161242,758778,1043639,414435,361947,399028,249640,209533,798414,960972,222695,924529,482842,883574,944966,711245,732780,715835,99720,790146,704883,112624,804039,298176,977031,889885,979931,946238,571681,287108,329270,763359,413000,436682,370463,1009152,887955,827347,399704,262161,607744,681440,655182,499302,5065,1036253,299349,1268,1026144,809538,172227,554905,920809,70112,939621,784318,135481,178301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]