SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392000 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392000 [ RunTime:0.004447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427754,824381,924807,930924,1002321,1010883,987368,688683,314136,79111,109526,2623,206552,703732,245917,13092,664941,106987,857807,218936,738132,873869,269826,417288,111398,388523,846940,361466,704255,80092,859367,883469,817526,975091,87917,526283,717287,751764,605695,742501,569306,321635,231830,573134,354708,10788,557179,614764,1893,421834,401870,901213,800055,459684,985998,9225,702007,110361,615909,205685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]