SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505609 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505609 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551629,808826,346601,507304,533806,926174,440711,556364,1037198,734260,696002,213473,622681,312832,292914,980770,285244,961375,727527,1002619,334735,849655,664917,70027,396808,906883,227849,333688,226883,138774,168589,84858,284679,511396,633315,205340,795339,677783,749608,461914,583064,205058,672949,960241,347378,40740,371283,570431,54747,762390,756238,69257,822755,355161,939566,864936,889535,249315,972343,380729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]