SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489209 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489209 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006210,235466,742677,319378,62597,264206,404094,7802,896503,437048,8588,429725,230865,415203,500861,254260,1018018,493622,507560,328270,30337,375481,930083,22759,168895,815368,705836,233163,196856,591348,444024,269725,1014030,1023979,2100,584239,990065,813160,49927,677987,399911,523187,287238,515572,63774,324626,42511,701825,929609,316373,418238,195409,1036835,934011,219505,97759,20616,467872,355976,1041798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]