SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591208 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591208 [ RunTime:0.001451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295243,62699,499090,558813,967676,130294,578890,450211,662940,157949,496843,520011,823765,94718,475657,562563,585798,490283,749241,424615,28568,641535,480441,351635,190563,911302,444897,100879,847103,13455,263728,663205,999971,595782,894193,436176,984088,974464,367645,795393,238762,439920,900319,165982,733190,723428,944178,1047778,342224,955135,950695,218267,284545,602740,595739,969720,491239,914136,943147,649769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]