SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554427 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554427 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436404,771247,469339,666294,640514,710762,594820,675501,527242,269623,116972,405810,949286,992925,581295,173547,683442,493823,545012,867714,207951,680357,890478,85423,399979,103971,144933,795143,102120,229413,990008,894038,173887,765252,320567,571855,165705,958619,177304,388892,89267,167482,118204,242038,931659,766829,959094,259653,995097,877535,920983,946312,311473,145236,303028,177215,755399,365467,410942,282685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]