SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410026 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410026 [ RunTime:0.003171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023396,419880,192751,187599,751498,984719,126807,780896,502880,839000,1039640,323147,578808,10643,341770,559192,378953,307946,981740,851254,446582,641608,714827,585030,885976,735697,197096,95668,1013661,750017,742504,440649,63255,985079,313324,880490,207136,954868,351570,527793,892413,503820,375406,647313,688325,587348,102917,816280,397029,92012,77553,150988,196119,668001,578043,600001,878693,761808,188537,184800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]