SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520188 LIMIT 1 [ RunTime:0.000921s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520188 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579620,919978,634925,886993,584276,417874,537649,512553,343745,175571,996745,306370,932880,904012,981039,674055,503276,366916,583229,218555,292374,514156,851878,305314,336578,81415,741009,999902,158729,277122,128804,970987,530775,601153,264250,910333,941922,168395,934424,747547,175814,770010,1028995,472905,50333,512182,826679,387228,847467,119013,958661,1010328,239783,330237,262702,204938,668257,431567,830458,717321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]