SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514475 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514475 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551101,37118,704986,425443,372027,687648,741636,527337,1025293,5204,618897,885191,578999,315149,380485,563524,897572,859541,626359,189159,857708,918002,382023,369110,189387,728080,499049,112434,980091,654538,866014,132628,345835,273632,920802,689463,998833,142984,989050,135449,349744,973119,883337,783277,1017259,729661,248395,395584,764560,243361,748347,560256,24722,279484,380858,736425,433713,293446,595496,953066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]