SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039289 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039289 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802180,827181,207165,753851,289118,833625,971891,926967,394364,641982,431361,675184,465411,371207,367415,433068,276647,187712,404868,751666,95749,692655,842753,222824,60822,799826,452545,614484,282693,314555,982754,558446,423008,617360,64789,67041,23356,300794,176414,590150,856201,405210,803535,273609,637144,625739,564474,728210,741917,970330,516406,524931,824668,181863,389899,1041556,161157,945577,766792,127372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]