SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260423 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260423 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601889,822739,717254,649316,836465,611155,351414,23545,138350,301139,163846,685877,841484,934537,394750,706355,110472,730151,504886,609690,1027786,987899,188567,17941,639894,142214,432660,518284,1011072,892395,333628,1004574,516844,970465,241556,563250,52341,967559,3199,762925,182197,158415,592118,392147,249060,541052,276028,171592,892864,899821,153424,869621,148669,500403,268020,151574,677409,513257,731256,283104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]