SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 722810 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 722810 [ RunTime:0.002030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906630,521424,989313,442416,406137,232757,158055,419484,739027,721054,568599,385980,351670,518558,394592,725560,873320,152363,108894,980111,888279,910884,832574,31600,539945,163635,281160,259530,633914,1026007,313638,24307,879259,554336,1019053,360349,678930,234218,494316,75454,403967,712771,175002,868391,699991,340493,952999,981662,150138,143948,478814,947799,127435,512352,273301,1034094,1008521,234506,24559,440546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 722810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000893s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 722810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]