SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536615 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536615 [ RunTime:0.002336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788105,232766,103500,447438,896541,746317,473461,326357,238735,484631,655968,156862,584066,659034,777922,552943,838370,289057,677603,821389,619977,245399,40094,109351,883504,548968,723897,561832,88677,702343,902406,38643,332928,545599,244269,388429,595385,763386,856831,201689,693871,152223,280911,457313,706354,384575,601064,970692,311980,404499,759042,315569,810225,913300,36440,170053,311201,368550,102247,191161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]