SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034350 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034350 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042782,572111,489991,785833,54961,634923,376025,28525,601938,779287,300298,126820,215231,927593,509652,325587,310078,306738,86294,424530,772984,539728,787734,821231,822532,1010590,502866,26083,532535,490209,578354,305571,1045305,269034,605989,960109,781832,665354,557252,551164,915212,15666,320210,942366,737517,425838,1048041,555084,596083,992345,724522,890229,632491,613373,688717,1000002,1035402,110493,489105,41032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034350 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034350 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]