SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002599s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 822180 LIMIT 1 [ RunTime:0.005763s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 822180 [ RunTime:0.008473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659013,116129,1048471,252593,155758,253790,725932,914534,33977,650447,561379,49089,127669,495340,858050,225842,935213,401324,451632,29291,512199,838063,801023,147586,771851,375335,976089,1019968,398923,838733,233532,236064,238904,462870,600080,346888,708112,929606,238722,567380,1005131,348519,596967,385634,83520,460656,442854,61376,405172,542185,789231,956054,709817,290861,57881,596357,244141,111925,302290,937085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 822180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 822180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001844s ]