SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426328 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426328 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97926,578661,703072,472055,56049,727088,160172,1029390,443051,326404,755212,68022,174775,768199,841504,805144,731764,720586,680642,703653,720530,177127,642571,979241,236870,36553,504449,506711,650012,27508,170662,227596,595797,1038585,655691,151333,215932,453570,448191,299209,407591,1029467,253088,310177,909429,378740,755713,547413,22572,960207,570127,544681,200076,587961,644853,551908,38737,12152,400317,709400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]