SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589080 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589080 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102971,292156,929953,866382,718587,545926,850882,461992,276282,271628,785292,324551,727881,508474,556559,253913,503273,649534,602386,232556,211810,730267,620778,643013,1048074,354217,476662,503063,516394,511618,347064,771669,125923,386494,283119,379149,741123,349985,274439,135257,531284,832688,737959,754902,495024,779833,209737,939737,207001,268114,144724,427476,608939,564917,57257,1015517,577767,172725,803062,164307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000836s ]