SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020519 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020519 [ RunTime:0.004943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521105,293694,124757,955699,768580,747094,411927,475322,961098,775995,623278,462650,904345,621790,306196,247591,704024,604469,476197,37702,131125,837978,867863,822418,915685,1048858,1029608,931086,47082,431708,218504,613906,600797,1027503,601097,403115,970103,816690,412175,812958,705219,101468,804174,862654,652093,68139,759365,438569,133423,462929,533085,646576,505424,882056,573724,132275,395067,252254,793484,537263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]