SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040518 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040518 [ RunTime:0.002319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94942,563747,461715,446339,911898,361195,453010,526046,338125,579493,821451,655199,405208,529534,885237,335418,629787,93423,471563,816317,843262,605246,828670,358417,442712,391566,872344,164897,736004,537458,385074,70066,172489,800446,181403,403833,569382,302811,631507,1025288,368156,820950,1005963,838040,375854,637055,893133,829489,144137,838228,380017,124350,599749,210358,57761,322919,638749,374449,41173,92936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]