SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200428 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200428 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303446,706044,468962,31668,197365,966956,514618,686839,677323,8010,896913,644307,373132,473139,892429,102898,769431,674845,133192,589341,607228,461873,964497,415984,487643,53143,912584,658148,383679,181382,349880,809655,499845,973484,361694,454920,863412,282023,699229,133227,895676,343858,304699,648984,1004717,178710,950291,662902,492673,71652,603767,348495,750944,85513,977214,467116,406434,55560,362368,640753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]