SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421359 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421359 [ RunTime:0.003955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668124,709477,760938,898901,51878,979048,698080,415371,1034451,111424,196482,58730,706356,78107,692077,493165,662348,642474,585339,287178,266518,828302,976432,369258,474614,33470,736010,491558,870760,365900,223688,826241,332373,1019411,105615,1034915,593037,582596,866840,829268,402675,1045042,513526,787843,112034,367124,482558,182838,370001,1002203,442865,351304,393488,546125,606411,907600,956713,884827,976053,376754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002861s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421359 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421359 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001257s ]