SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454352 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454352 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567336,844490,286146,304342,405828,436386,229246,826735,214800,155187,706330,112864,414248,846937,219590,404673,861513,168773,157108,729070,77189,950633,826711,409545,85807,684030,385811,985681,360815,234694,343048,1024398,893380,84828,810202,960949,38857,237742,1045891,1023955,349914,100623,802631,1010288,24084,792411,670465,608641,523176,375551,556141,398865,946712,915397,50174,251343,922528,496413,104904,874952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001336s ]