SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412668 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412668 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699524,353083,754739,665316,117579,44531,309978,124936,131746,465769,711088,866437,96709,803083,190082,1009448,825390,810311,1010211,434298,488734,684655,339885,206716,885187,501737,945296,619682,68741,926088,775172,33763,350706,869087,932211,914253,686353,974324,596533,564935,655149,380652,134924,8641,600311,165185,982214,178049,352510,514909,687716,763034,1048375,938233,789578,1036003,421556,891753,689209,350974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]