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` = 418591 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418591 [ RunTime:0.003534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913473,1016347,854808,21450,1045949,827504,859333,540946,422236,480926,279022,363675,799388,827008,91042,680618,1018436,998530,642720,684442,874784,707603,178280,895070,326333,518837,440016,5466,482703,262299,1044851,912033,128800,284627,392950,370658,350319,442566,942451,498816,42144,946100,520893,176423,1035219,782052,641455,902331,10268,433025,133052,901410,4173,14964,199927,902884,904465,237196,741762,450650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]