SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 844685 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 844685 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005271,431398,254289,894146,661509,2003,377178,699730,710659,33478,847884,362536,298933,160801,408795,67817,571643,164147,519382,947497,451964,1004576,104030,817217,319921,803472,839310,337167,119340,333570,436956,549128,541152,741212,428802,1042292,578541,479653,670047,327677,630911,564863,730036,671327,809143,861951,553000,985505,239172,1036013,631932,632074,922127,213848,240637,557036,763937,559396,1030553,478876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 844685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 844685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000800s ]