SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001995s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314623 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314623 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217760,55126,737190,966436,601317,1045988,875469,962428,199542,512450,942859,222013,4731,426121,346565,916830,891973,926750,38176,190669,900797,293847,305532,32772,528606,684612,500028,424058,416181,381131,262024,267421,700362,80558,591434,522935,816748,566094,933265,881001,413158,328272,730714,671924,317138,201553,210758,36716,104209,109170,319879,496148,389751,500493,418779,1038218,794245,137006,918879,594803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]