SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531064 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531064 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326657,68103,529451,596273,596879,886515,19386,150427,882174,800629,687325,807108,390402,959821,170910,411767,822456,121407,479585,80043,1036442,851759,149873,345110,45048,54222,602470,39848,760834,608810,699921,27040,822000,130311,894543,51788,478448,86527,1003250,161072,950346,117081,731265,857659,604962,153010,949524,153418,603871,852322,927928,878231,654017,474717,535617,741849,717780,342414,1029293,985607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]