SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602580 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602580 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412570,15236,736840,992116,779151,242364,593640,648619,111898,73546,393980,288262,143967,324789,591763,389001,837639,73755,906534,675390,254608,962232,46310,454708,154390,608609,440062,310041,594690,404981,548063,173253,809545,363530,95823,1033402,578624,522998,812471,802435,89289,558725,988999,479829,229818,218783,183116,842071,135796,773516,27370,399921,804730,314064,796648,409980,809910,594263,489928,73069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000860s ]