SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317698 LIMIT 1 [ RunTime:0.000805s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317698 [ RunTime:0.002086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869946,1015860,748644,529320,872914,602212,335422,11968,776156,98824,688618,304591,440665,1012810,157078,257072,89977,334129,290180,1039939,702607,601757,693513,559545,291156,517749,481460,281962,624149,387780,555751,523491,435751,36621,1003137,222644,823657,470502,901555,216029,990194,918869,596696,272788,306562,320320,762461,1032512,540022,850832,399305,318331,478653,739870,707525,56412,188263,719583,492138,816519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]