SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284098 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284098 [ RunTime:0.002350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005106,651384,982398,413827,960424,897593,797801,108004,616030,904245,725550,636668,381356,742958,849899,361718,716192,467033,879116,566918,947760,862539,231196,663477,416842,798926,74583,1031125,38941,974714,408613,771533,263807,773724,784912,694829,714414,379318,705361,134640,857226,226704,872901,323045,901415,698113,398701,1039588,652611,803553,560330,534922,626832,585479,189270,678212,740477,492890,224724,899914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]