SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005014 LIMIT 1 [ RunTime:0.004722s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005014 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416878,433808,121351,223821,168820,479734,270969,974545,141805,938256,479669,601781,707852,657303,501621,1007598,412998,254737,64347,635786,611877,296045,494681,210250,592370,881288,978795,843966,591914,429398,696184,392261,46967,803000,779609,715061,810936,742489,540403,661377,674913,764185,979237,514638,679500,199408,925462,844142,547228,1024355,299569,383322,934440,336269,242578,420438,682209,946245,470844,643426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002553s ]