SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428505 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428505 [ RunTime:0.002184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909973,275218,895771,919935,1032400,255084,921109,982867,622302,742573,307237,257474,969477,173571,713119,958183,563910,1027304,437591,40475,386779,608348,768934,291483,889512,528386,102931,851354,479443,411216,120685,691767,243677,450818,370428,718385,190751,677910,619110,96439,93913,617269,741397,166281,178722,37166,556262,1003518,254600,21712,982939,582813,671260,24782,1015554,71290,33011,917378,889746,440892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]