SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300072 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300072 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182771,374627,341780,704640,639820,471921,116962,102278,420759,920635,746419,172303,415947,858592,391066,471195,40330,355312,26290,734711,1028917,241803,258630,466042,187356,728935,491047,190613,81644,212080,990334,688250,218882,98251,156102,108030,785258,106144,971130,501670,252060,360427,595873,379332,631518,227334,526239,872053,40741,461580,697760,785242,470854,422948,814486,361068,807411,351194,335404,732687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]