SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44187 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44187 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575168,835492,596326,175997,377719,231363,902366,593054,683469,200548,112292,198783,998390,520631,227197,327470,238649,804730,257318,421276,1032779,300491,848999,671189,924701,502854,147861,673343,506291,484055,873769,857049,977692,895644,242209,347076,417844,136809,241708,462680,412793,563442,1013250,134058,506630,364233,744907,464828,37056,684313,291774,726873,825197,386065,573745,7550,645073,541453,225462,423758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]