SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415679 LIMIT 1 [ RunTime:0.001508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415679 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634807,166820,383223,216294,303474,574946,473689,470355,516244,124837,118845,942966,250213,580556,1036654,401702,8257,320399,482407,660147,525035,464084,394193,275516,10559,532044,52456,514913,866031,367893,571987,201765,514708,510175,169670,825909,988230,599088,223934,176153,688839,244558,769078,926818,434771,96721,502891,137444,827860,572971,699808,192425,589395,184462,323507,664191,98762,829150,891360,122976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]