SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344498 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344498 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791493,523469,552068,963185,331596,751839,531674,66091,874980,26479,361501,201029,19734,865420,378613,325418,267443,739327,322032,1020699,824593,626929,303017,822008,498180,624472,456273,369097,462053,738282,887472,209800,807408,253724,329766,2793,945350,169286,641513,765136,708670,87458,233774,502548,148447,966179,33803,295243,325847,73601,487487,792900,893125,564843,626712,244724,171698,99352,761649,301415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]