SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550313 LIMIT 1 [ RunTime:0.000719s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550313 [ RunTime:0.003636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019677,761342,460768,54257,679421,838608,171571,393720,391307,762075,561968,962894,313720,501966,1026938,672695,218978,229743,170519,861695,285516,982874,219724,833679,93654,49550,165930,762844,701298,247642,494728,205538,1024990,231209,286581,656962,113959,467093,328854,996811,537939,796399,962857,289653,74566,553053,930884,142296,818421,680447,505717,189224,476310,1018262,85553,109777,709411,196106,163314,70035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]