SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016941 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016941 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47556,504933,62601,844538,6967,853198,629568,111342,980317,975746,318034,252071,624053,955754,32683,674119,740623,697103,488583,114581,714168,165788,963685,440226,141771,257238,937053,417859,441368,37234,137442,184114,986730,502969,377389,1030664,257157,413345,944361,263108,620463,587123,787220,861438,346870,730922,316943,834735,37649,617095,572979,376316,45704,646584,67497,847908,348705,734148,314259,1039644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]