SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001723s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190903 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190903 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732182,1044893,34216,455003,944252,567453,714309,951352,116048,426533,245479,1037830,576619,650925,811343,1047096,903539,56589,797960,121201,968805,587373,281654,239676,419780,601735,272895,724987,235724,71830,363943,500678,633077,913124,66027,152919,269924,948791,402085,806216,942171,517891,935385,901690,466038,424654,205747,646459,187746,313584,113312,296260,60788,919296,139434,629062,345137,23664,507529,892611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]