SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522458 LIMIT 1 [ RunTime:0.001236s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522458 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463117,86713,1012314,478571,766156,987521,565142,856840,878677,259906,815512,843988,698085,189987,253790,511609,343749,941013,527517,523138,234991,534579,390964,1021904,149974,674157,369423,1031932,201826,641828,673571,1011885,344412,744980,730385,310664,1013279,127590,323956,506202,215812,17622,314338,317382,270850,247289,769697,116895,393984,944987,912984,201380,909505,732031,690476,1007766,208583,1036382,909191,289335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]