SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429241 LIMIT 1 [ RunTime:0.001117s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429241 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140067,812555,435381,308355,374652,822909,398606,133803,922124,113332,742997,788881,1020457,985964,568365,179951,622958,766872,440026,751663,985067,688902,1010204,557872,476999,1033705,35481,986653,686704,266123,971988,1039139,860718,48819,328434,955296,964393,420694,134218,263321,776154,554642,726820,1040214,435056,710912,1048095,73670,820796,979554,314609,119916,136298,598825,243626,130300,262793,932230,153962,556276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000769s ]