SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533088 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533088 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629025,175320,541141,543281,244726,828492,10659,788118,245199,397472,889629,734673,245449,505768,406429,587203,621414,183637,500849,377904,75100,616603,1047744,817545,579798,924716,875345,97263,904629,162912,292670,457645,214952,809695,597696,1011360,847118,713986,176194,54260,298667,528911,1037536,59347,488812,583435,870892,969543,964995,511321,856891,32383,999523,983325,947589,946854,244755,678913,622199,888972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]