SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526649 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526649 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407809,54397,808841,889578,816248,255287,295008,7902,313875,41373,132523,48419,596942,634037,295561,500262,235444,440089,11887,1060,917938,949174,954419,272271,633392,85453,440323,434283,926359,75953,128600,257850,210398,270437,373041,820747,90493,698598,734630,231706,733701,177833,388007,681434,519893,811053,778411,197745,996336,303591,241114,346348,11670,32899,442360,318778,149633,658362,127843,103335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526649 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526649 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]