SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341683 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341683 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544932,1008115,175502,381630,959106,144256,307192,289021,51537,640406,64968,420209,617115,987356,421268,210423,805032,374103,498741,659697,972400,322583,771400,295042,1043676,609751,439095,496021,988721,504125,629650,645689,741280,845984,294401,791023,680977,263720,182707,908263,341550,215211,718162,20550,390498,818026,684390,238023,713106,791526,879345,456183,124759,418626,69243,756927,616589,85481,194033,223375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]