SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294403 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294403 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841020,564406,612222,349103,1035038,973,630013,155451,562625,50240,451856,370269,650801,641075,65612,851874,259283,876802,941192,542461,469903,922418,272208,269761,333973,733946,743487,9640,699473,851127,914648,340049,346771,63419,463972,285458,589295,692037,874141,239563,605924,964063,1018256,282975,1026547,380904,195877,751163,392360,393256,768450,299340,996657,570599,612595,285168,764632,803101,977783,161608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]