SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447198 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447198 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748361,127862,110157,611720,342486,136126,944157,516223,800156,116455,230165,607402,848784,674695,783226,957134,479877,983566,553745,923392,977023,307997,217752,172780,279300,1019634,365452,985333,357831,773639,990814,873410,69542,388008,920884,740223,89547,516973,563034,463951,3425,224722,670578,765139,791821,196715,977841,302412,303159,642477,383325,1044138,1011169,93556,336435,602177,332589,538374,296430,978846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]