SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55484 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55484 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435383,249653,424503,605507,25951,552103,112169,221234,241013,876320,134944,562512,36964,396203,179633,653652,30672,100402,182548,184155,446424,236116,29295,371480,777462,738665,441985,167231,282047,673295,447574,94105,313995,831938,771893,955648,466593,360183,117577,141582,480518,450217,1024594,904172,44676,622572,1011148,665401,425209,557226,807101,878620,655271,86129,91188,147137,738741,209793,193510,583060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]