SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406449 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406449 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614063,44322,852794,1020999,746964,969016,36402,447542,865086,1924,527171,709154,801571,271094,962474,792056,228957,614797,884527,890340,791595,59805,919854,559106,218061,151424,322380,333172,24942,204162,660562,301411,906913,791309,182341,626436,835976,768952,1037761,1018558,966944,114978,541102,1378,147318,70767,964846,329300,951721,165838,206052,166102,93635,712471,19242,902717,12119,1010286,845708,1020771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]