SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422424 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422424 [ RunTime:0.003316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98500,397245,630141,720831,203639,103383,562522,80203,412533,1005541,274805,316778,560479,399240,368246,749255,604240,206463,740432,745767,20123,888780,89072,656648,493236,977366,615858,107887,115941,773057,623554,311471,222093,873066,917286,705054,175267,724862,655926,786796,205660,832733,919824,504346,49160,883390,937292,745916,609903,612302,54957,815020,107919,230142,661681,686455,587959,101543,563484,220958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]