SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528096 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528096 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698164,804268,72558,199110,927781,850597,724579,649359,934187,41431,826938,270693,10936,980044,863700,613705,668224,691967,477252,784786,161467,583733,965466,333059,201774,381518,217133,139914,799892,978430,756849,58100,263912,219066,102134,684638,371426,1005560,536183,450405,466343,839297,643634,713257,847836,902857,472850,821379,192958,909209,2436,378935,761113,199368,285938,172828,885163,716794,499520,646896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]