SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395045 LIMIT 1 [ RunTime:0.003098s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395045 [ RunTime:0.004483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624809,628364,562538,873223,997084,759481,796060,312320,24148,534760,803093,413412,858368,1021971,901924,660396,63877,338088,954769,850790,599965,1012084,312470,143918,841504,13567,231747,851941,969594,296874,18353,554085,529646,208553,351427,293343,839620,707377,412058,264376,284884,408895,761593,860829,819860,802393,452712,896331,103642,930519,828414,995827,12802,487488,801833,250724,994011,711658,241882,24059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002768s ]