SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044084 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044084 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021673,932162,1042889,487558,830604,905843,6169,565862,750732,637938,1018650,965359,439623,579496,59357,336697,443807,254106,865212,585429,86583,869299,916411,746409,752107,272591,648792,133252,859568,865515,63045,709071,681502,259630,694936,1006042,130232,578034,483433,214198,720629,281557,966808,82980,545990,606572,720242,201140,124312,370087,912179,999426,288327,535659,920142,308793,122953,767155,427175,757806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]