SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 698307 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 698307 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404687,778711,676289,792912,692007,850282,168415,47943,1005282,664278,801032,604931,877545,64002,242374,45305,379324,490301,942853,122331,349816,733473,768447,577511,775841,722811,215391,811053,40369,668879,254467,597453,387495,376634,500046,429318,704877,450238,758743,1032760,665036,270214,631548,334744,1044054,604763,919895,484493,831566,1778,689956,554733,977531,234645,555428,1004014,953307,40956,986167,520036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 698307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 698307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]