SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410423 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410423 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75525,153683,201014,227467,1027692,57488,821826,204727,678252,836308,277060,441281,11048,10786,975304,950000,319694,861424,691718,611513,34984,693119,635909,891150,942717,243865,991428,1046015,895419,626752,974703,553720,19205,91607,859773,392445,42404,894414,953814,664113,966806,775317,678597,226051,654180,119159,528801,603289,418823,263576,389866,285598,80110,82396,494990,10845,372998,773359,888696,22208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000762s ]