SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002454s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047668 LIMIT 1 [ RunTime:0.003780s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047668 [ RunTime:0.003024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428005,598108,677033,223596,309054,960048,976219,16233,233909,813589,663782,513285,403337,377550,644960,258270,640046,620679,518774,395247,304674,483679,125028,752091,210673,64845,877305,972748,218050,646209,16847,308144,397137,456553,895178,691305,327699,1017571,958340,323650,704158,724206,918830,264183,271803,597296,168507,280711,986241,389219,493927,945162,333346,512280,905683,605958,834799,70635,925919,881683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000759s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]