SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028400 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028400 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433171,256699,976836,971922,370235,902817,11969,26226,876826,58215,687888,633472,713412,762852,606086,319264,555356,161034,882525,796591,639334,1027423,281382,691881,962955,1039716,85885,887603,383701,248036,214652,334963,247556,803882,92711,64754,904973,19544,979353,852548,200220,172725,158801,651456,659406,338683,865039,754885,957435,763451,1047075,236502,577110,694335,88525,322039,22818,184312,12270,103821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000771s ]