SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001657s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 572179 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 572179 [ RunTime:0.006376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002082,200116,439555,283893,1044326,257440,1034820,474341,1031883,612689,227062,1048071,444540,70860,672460,532367,950807,410094,575245,690365,932678,794891,307487,958030,990788,789958,443840,724183,252012,722742,476038,529785,685694,608619,143294,117867,303536,706442,890131,101186,1006212,595943,791586,983226,398822,437232,464218,587480,939149,746518,942350,614822,580639,929168,368949,464491,806349,772094,712978,113389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 572179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 572179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001796s ]