SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002880s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806997 LIMIT 1 [ RunTime:0.003789s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806997 [ RunTime:0.005864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510415,54407,46067,659372,544136,431529,1042365,548744,601699,291735,269866,361430,271558,168799,705193,254534,285572,960416,353777,1017526,585187,264312,511082,193839,928926,881417,718382,689165,829776,352688,172849,701349,892512,618906,182526,122246,101072,561346,293807,984193,191038,746249,837133,831168,621026,402825,113888,224680,249323,973880,543074,439167,346015,904515,415988,1017083,408107,660837,444921,94982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]