SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408943 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408943 [ RunTime:0.003902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122614,463491,669749,474596,637643,718789,785257,161756,65056,238926,70440,590482,561441,924284,662694,176775,678934,668853,930106,868361,695919,547857,751499,862713,141242,70744,335530,234772,762057,945134,564239,39500,545050,272502,153433,410095,964122,951026,158345,1028681,259898,223698,28819,738737,359308,1015307,202908,551568,466714,267727,841675,641053,381953,851581,224573,213326,243399,744663,712,586006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]